2013-12-12 - 6474 - Spec - SNC PO FTP File to FF #SNCProject #ABAPREPORTS #ABAPSNC

6400.200- PO FTP File to FF

Purpose

Notify Logistics vendor by sending a file with the list of POs

Admin Info

Purpose

PO FTP File to FF
Requested By
 Jeffrey M. Mau / Rahul Attarde
Spec Created By
 Venkat Kondapally
Spec Created Date
 12/10/2013
Spec QA by
 Adithya and Vengal
Objects
 ZSNC_PO_EXTRACT
Document Status
 Complete

References

Prior Tickets

N/A
Documents
N/A

Functional Requirement

As part of SNC Implementation, PO information is sent, along with weight and volume, to Freight Forwarder for which EX-factory date < 90 (Lead ) days so that Freight Forwarder can plan accordingly on daily basis
FTP file has to be generated and send to FTP Server

  1. Generate PO download file for each Freight Forwarder/Shipping Instruction Number at item level.
  2. Based on the freight forwarder – add the shipping instruction number at the start of the file name and send it to specified SAP folder. (eg – Mohawk Ocean is 57, so the filename should be 57_PO_.csv
  3. Create a script to pull these files from SAP AL11 folder and put the files in shared directory
  4. Create a script to FTP files based on freight forwarder (we currently use only 5 freight forwarders)
  5. When Should we send PO,
a) PO data is created and
b) PO is changed with the following fields,

MSRP SO: get the Data from ZCRS and ZMRP maintained in the sales order.
MSRP PO: get the value for non SO Purchase orders in the MSRP PO filed from table A552.

Selection Criteria

Solution Summary

Basically same as sent from DSCCO today except
- Detail is at line level instead of grid and File is generated per Freight Forwarder/Shipping Instruction Number.
- Generated Files are placed in AL11 transaction.

Solution Details

Proposed - Solution Approach & Impact:

Basically same as sent from DSCCO today except
- Detail is at line level instead of grid and File is generated per Freight Forwarder
- All PO’s are maintained in a Custom Table, along with shipping instruction number, for tracking sent PO's
- If the File is sent to Freight Forwarder, sent date and time stamp is updated.
- The PO for which Ex-Factory Date condition is not matched will have blank date and timestamp
- Whenever a PO is changed the date and time stamp are set to blank till they are sent to FF

Output:


Field
 Comments
1RecordIndicatorTag
 HardCoded "NEC PO"
PO Number
 Po number
PO Line
 Line Item
PO Ship to Name
 Ship To
PO Ship to Address
 Ship To address
PO Ship to City
 City
PO Ship to state
 State
PO Ship to ZIP
 Postal Code
PO Ship to Country
 Country
PO Ship to Country ISO
 Country Code
SKU Number (Material)
 Material Number
Product Description
 Material Description
NMFC
 Commodity Code
MRSP SO
 MSRP Price
Size
 Grid Value - Fill Blank
Size2
 Collection - Fill Blank
Order Quantity
 Order Quantity
UPCSO
 Fill Blank
Latest Ship Date (EX Fac)
 Ex-Factory Date
Net Price
 Net Price
Sales Order
 Sales order Number
SO Ship to Code
 Sales order Ship To
SO Ship to Name
 Ship To Description
SO Ship to Address
 Ship To Address
SO Ship to City
 City
SO Ship to state
 State / Region
SO Ship to ZIP
 Postal Code
SO Ship to Country
 Country
SO Ship to Country ISO
 Country Code
Ship Via
 Customer group 2
Service Level
 Fill Blank
Payment Terms Description
 Payment Terms
Customer PONum
 Customer Po Number on Sales Order
Cust PO
 Customer PO Date
Req Deliv Date
 Required Delivery Date
Cancel Date
 Valid-to date on Sales Order
Sold to ID
 Sold To Party
Z100
 Fill Blank
SO Line
 Sales order Line
Vendor SKU
 Vendor Material Number
Confirmed Quantity
 Confirmed Quatity
Mode of Transport
 Shipping Instructions
PS ID
 PeopleSoft ID
MSRP PO
 MSRP Price
UPCPO
 Fill Blank
PO Issued Date
 Po Issue Date
Order Company
 Company Code
Vendor Code
 Vendor Number
Vendor Name
 Vendor Description
Origin City
 Vendor City
Style Name
 Material Collection
Buyer Name
 Authorized Signatory
PO Ref 1
 Plant
DC Ship To Code
 Plant Description
Order Type
 PO Order Type
Order Qty UOM
 Ordering UOM
Release Num
 Fill Blank
Delivery Required
 Fill Blank
PO Deleted
 Deletion Status from Freight Forwarder
Booking Qty
 Booked Quantity
Ctns
 Fill Blank
Ctns UOM
 Fill Blank
Weight
 Fill Blank
Weight UOM
 Fill Blank
Volume
 Fill Blank
Volume UOM
 Fill Blank
Booking Num
 Fill Blank
Container Num
 Fill Blank
Commercial Inv Num
 Fill Blank
Reserved 1
 Fill Blank
Reserved 2
 Fill Blank
Reserved 3
 Fill Blank
Reserved 4
 Fill Blank
Reserved 5
 Fill Blank

Test Plan


Test Scenario
 Expected Result
Create Multiple PO's from Multiple SO's with different Shipping Instruction ID and Ex-Factory Dates
 One File per Shipping Instruction ID with naming convention as specified.
The PO Lines which have Ex-factory date within the next 90 days are included in the file.
Confirm all fields are as specified
Delivery Quantity Change in Purchase order
 The entire PO line Items which have Ex-Factory date with in the next 90 days should be included in the file
Shipping Instructions change in Purchase Order
 The entire PO line Items which have Ex-Factory date with in the next 90 days should be included in the file.
The PO line which is changed should be included in two files,the Old shipping instructions file should have a deleted indicator.
Exfactory Date change in the Purchase Order
 The entire PO line Items which have Ex-Factory date with in the next 90 days should be included in the file
Incoterm change in the Purchase Order
 The entire PO line Items which have Ex-Factory date with in the next 90 days should be included in the file
Delivery Date Change in the Purchase Order
 The entire PO line Items which have Ex-Factory date with in the next 90 days should be included in the file
Bugs Found:
1. The Other POs which are not relevant to the Vendor which is given as the input are also coming in the file.
Solution : Program to exclude such kind of POs
2.

Issues